Tabela UserGroupHist

Definicja tabeli UserGroupHist

Name

UserGroupHist

Code

UserGroupHist

Comment

 


Lista kolumn tabeli UserGroupHist

Name

Code

ID

ID

HospID

HospID

ExtID

ExtID

Descr

Descr

Active

Active

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

AccountNo

AccountNo

CustomerContractNo

CustomerContractNo


Kolumna ID tabeli UserGroupHist

Definicja kolumny ID tabeli UserGroupHist

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospID tabeli UserGroupHist

Definicja kolumny HospID tabeli UserGroupHist

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExtID tabeli UserGroupHist

Definicja kolumny ExtID tabeli UserGroupHist

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna Descr tabeli UserGroupHist

Definicja kolumny Descr tabeli UserGroupHist

Name

Descr

Code

Descr

Data Type

VARCHAR2(256)

Mandatory

No

Comment

 


Kolumna Active tabeli UserGroupHist

Definicja kolumny Active tabeli UserGroupHist

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdUserID tabeli UserGroupHist

Definicja kolumny UpdUserID tabeli UserGroupHist

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli UserGroupHist

Definicja kolumny UpdNr tabeli UserGroupHist

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli UserGroupHist

Definicja kolumny UpdDate tabeli UserGroupHist

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli UserGroupHist

Definicja kolumny UpdTime tabeli UserGroupHist

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli UserGroupHist

Definicja kolumny LockUserID tabeli UserGroupHist

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli UserGroupHist

Definicja kolumny LockTime tabeli UserGroupHist

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountNo tabeli UserGroupHist

Definicja kolumny AccountNo tabeli UserGroupHist

Name

AccountNo

Code

AccountNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna CustomerContractNo tabeli UserGroupHist

Definicja kolumny CustomerContractNo tabeli UserGroupHist

Name

CustomerContractNo

Code

CustomerContractNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment